Let’s perform validation checks on that table:
| Pointblank Validation | |||||||||||||
| QA checks - 2. Is the data Valid?
tibble
waste raw datasetWARN
0.00
STOP
—
NOTIFY
—
|
|||||||||||||
| STEP | COLUMNS | VALUES | TBL | EVAL | UNITS | PASS | FAIL | W | S | N | EXT | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Check that are no NULL/NA values in column
|
— |
|
✓ |
488 |
4881.00 |
00.00 |
○ |
— |
— |
— | ||
| 2 | Check that are no NULL/NA values in column
|
— |
|
✓ |
488 |
4881.00 |
00.00 |
○ |
— |
— |
— | ||
| 3 | Check that are no NULL/NA values in column
|
— |
|
✓ |
488 |
4881.00 |
00.00 |
○ |
— |
— |
— | ||
| 4 | Unique rows per indicator
|
— |
|
✓ |
77 |
771.00 |
00.00 |
○ |
— |
— |
— | ||
| 5 | Unique rows per indicator
|
— |
|
✓ |
52 |
521.00 |
00.00 |
○ |
— |
— |
— | ||
| 6 | Unique rows per indicator
|
— |
|
✓ |
64 |
641.00 |
00.00 |
○ |
— |
— |
— | ||
| 7 | Unique rows per indicator
|
— |
|
✓ |
62 |
621.00 |
00.00 |
○ |
— |
— |
— | ||
| 8 | Unique rows per indicator
|
— |
|
✓ |
30 |
301.00 |
00.00 |
○ |
— |
— |
— | ||
| 9 | Unique rows per indicator
|
— |
|
✓ |
47 |
471.00 |
00.00 |
○ |
— |
— |
— | ||
| 10 | Unique rows per indicator
|
— |
|
✓ |
54 |
541.00 |
00.00 |
○ |
— |
— |
— | ||
| 11 | Unique rows per indicator
|
— |
|
✓ |
55 |
551.00 |
00.00 |
○ |
— |
— |
— | ||
| 12 | Unique rows per indicator
|
— |
|
✓ |
47 |
471.00 |
00.00 |
○ |
— |
— |
— | ||
| 13 | Check that columns is numeric
|
— |
|
✓ |
1 |
11.00 |
00.00 |
○ |
— |
— |
— | ||
| 14 | Check that columns is numeric
|
— |
|
✓ |
1 |
11.00 |
00.00 |
○ |
— |
— |
— | ||
| 15 | Check that columns is numeric
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 16 | Check that columns is numeric
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 17 | Check that column in integer
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 18 | Check that column in integer
|
— |
|
✓ |
1 |
00.00 |
11.00 |
● |
— |
— |
— | ||
| 19 | Check that year col is between 2000 and current 2024
|
|
✓ |
488 |
4881.00 |
00.00 |
○ |
— |
— |
— | |||
| 20 | Check that year col is between 2000 and current 2024
|
|
✓ |
488 |
4870.99 |
10.01 |
● |
— |
— |
||||
| 21 | Check that values containg numbers only
|
|
✓ |
488 |
4881.00 |
00.00 |
○ |
— |
— |
— | |||
| 22 | Check that values containg numbers only
|
|
✓ |
488 |
4870.99 |
10.01 |
● |
— |
— |
||||
| 23 | Check that values containg numbers only
|
|
✓ |
488 |
4881.00 |
00.00 |
○ |
— |
— |
— | |||
| 24 | Check that values containg numbers only
|
|
✓ |
488 |
4870.99 |
10.01 |
● |
— |
— |
||||
| 25 | Check comments where the word wrong or probably/likely wrong is mentioned
|
|
✓ |
488 |
4680.96 |
200.04 |
● |
— |
— |
||||
| 26 | Check comments where the word wrong or probably/likely wrong is mentioned
|
|
✓ |
488 |
4810.99 |
70.01 |
● |
— |
— |
||||
| 2024-06-27 16:01:32 -03 < 1 s 2024-06-27 16:01:33 -03 | |||||||||||||